Analyze main jobs

Variables with the prefixes ARBLONN_ARB_ and ARBLONN_LONN_ contain information related to all employment relationships registered through the A scheme. These data have job/work relationship as unit level, and not person. And individuals can in principle have more than one job at any given time. In other words, there will be more observations than the number of individuals at any given time in the dataset.

When you want to create statistics or analysis of jobs on individual level, you are often interested in information relating to a selected type of working relationship per individual, e.g. the main employment relationship, the job with the highest vacancy rate, the job with the highest agreed working hours or the job with the highest monthly salary.

The example below shows how to proceed to analyze jobs defined as main work relationship.

 require no.ssb.fdb:31 as db

//Create a job dataset of active jobs per 16/7 2023, and find main jobs per individual
create-dataset main_jobs
import db/ARBLONN_ARB_YRKE_STYRK08 2023-07-16 as occupation
import db/ARBLONN_ARB_STILLINGSPST 2023-07-16 as position_pct
import db/ARBLONN_ARB_HOVEDARBEID 2023-07-16 as main_job
import db/ARBLONN_ARB_ANSETTELSESFORM 2023-07-16 as employment_form
import db/ARBLONN_ARB_ARBEIDSTID 2023-07-16 as working_hours
import db/ARBEIDSFORHOLD_PERSON as personid

textblock
Number of active jobs as of 16/7 2023 in the job dataset, divided into main jobs and secondary jobs:
endblock
tabulate main_job, missing
keep if main_job == '1'

textblock
Position percentage and agreed working hours for all main jobs:
endblock
summarize position_pct working_hours
histogram position_pct, bin(5) percent
histogram working_hours, bin(5) percent

textblock
Position percentage and agreed working hours for all main jobs, divided by the form of employment:
endblock
tabulate employment_form, missing
tabulate employment_form, summarize(position_pct, working_hours)

//Aggregate job data up to individual level, and link personal data to create personal statistics
collapse(mean) position_pct working_hours, by(personid)

create-dataset persons
import db/BEFOLKNING_KJOENN as gender
merge gender into main_jobs

use main_jobs
textblock
Position percentage and agreed working time for all main jobs, divided by gender:
endblock
tabulate gender, missing
tabulate gender, summarize(position_pct, working_hours)